SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateSurveyThemes]

	(
	@param_id INT,
	@param_topic NVARCHAR(100),
	@param_type NVARCHAR(50),
	@param_update_time SMALLDATETIME,
	@param_user_update NVARCHAR(50),
	@param_start_time SMALLDATETIME,
	@param_end_time SMALLDATETIME
	

	)

AS
	/* SET NOCOUNT ON */
	
	UPDATE dbo.JOL_SurveyManagement_Theme 
	SET
	topic=@param_topic,
	type=@param_type,
	update_time=@param_update_time,
	user_update=@param_user_update,
	start_time=@param_start_time,
	end_time= @param_end_time
	WHERE
	id=@param_id
	RETURN
GO
